Tabela OncologicCardHistSnapshot

Definicja tabeli OncologicCardHistSnapshot

Name

OncologicCardHistSnapshot

Code

OncologicCardHistSnapshot

Comment

Tabela jest migawka historii karty onkologicznej, zawiera klucze obce do wierszy poszczególnych tabel historycznych oraz do wlasciwej karty onkologicznej.


Lista kolumn tabeli OncologicCardHistSnapshot

Name

Code

OncologicCardHistSnapshotID

OncologicCardHistSnapshotID

OncologicCardID

OncologicCardID

OncologicCardHistID

OncologicCardHistID

OncologyBasicHistID

OncologyBasicHistID

OncologyInitialHistID

OncologyInitialHistID

OncologyDeepHistID

OncologyDeepHistID

OncologyHospitalHistID

OncologyHospitalHistID

OncologyConsultationHistID

OncologyConsultationHistID

OncologyTreatmentPlanHistID

OncologyTreatmentPlanHistID


Kolumna OncologicCardHistSnapshotID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologicCardHistSnapshotID tabeli OncologicCardHistSnapshot

Name

OncologicCardHistSnapshotID

Code

OncologicCardHistSnapshotID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID migawki karty onkologicznej


Kolumna OncologicCardID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologicCardID tabeli OncologicCardHistSnapshot

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OncologicCardHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologicCardHistID tabeli OncologicCardHistSnapshot

Name

OncologicCardHistID

Code

OncologicCardHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Kolumna OncologyBasicHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologyBasicHistID tabeli OncologicCardHistSnapshot

Name

OncologyBasicHistID

Code

OncologyBasicHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Kolumna OncologyInitialHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologyInitialHistID tabeli OncologicCardHistSnapshot

Name

OncologyInitialHistID

Code

OncologyInitialHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Kolumna OncologyDeepHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologyDeepHistID tabeli OncologicCardHistSnapshot

Name

OncologyDeepHistID

Code

OncologyDeepHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Kolumna OncologyHospitalHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologyHospitalHistID tabeli OncologicCardHistSnapshot

Name

OncologyHospitalHistID

Code

OncologyHospitalHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Kolumna OncologyConsultationHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologyConsultationHistID tabeli OncologicCardHistSnapshot

Name

OncologyConsultationHistID

Code

OncologyConsultationHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Kolumna OncologyTreatmentPlanHistID tabeli OncologicCardHistSnapshot

Definicja kolumny OncologyTreatmentPlanHistID tabeli OncologicCardHistSnapshot

Name

OncologyTreatmentPlanHistID

Code

OncologyTreatmentPlanHistID

Data Type

NUMBER(15)

Mandatory

No

Comment

 


Lista kluczy tabeli OncologicCardHistSnapshot

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologicCardHistSnapshot

Definicja klucza Identifier_1 tabeli OncologicCardHistSnapshot

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment